Pandas Profiling Report

Dataset statistics

Number of variables	21
Number of observations	1299
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	682.3 KiB
Average record size in memory	537.9 B

Variable types

NUM	15
CAT	5
UNSUPPORTED	1

Reproduction

Analysis started	2021-02-21 21:32:44.068047
Analysis finished	2021-02-21 21:33:18.420617
Duration	34.35 seconds
Version	pandas-profiling v2.7.1
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

`title` has a high cardinality: 1291 distinct values	High cardinality
`deltaMedianPrice` is highly correlated with `price` and 1 other fields	High correlation
`price` is highly correlated with `deltaMedianPrice`	High correlation
`deltaAvgPrice` is highly correlated with `deltaMedianPrice`	High correlation
`dublinNorthSouth` is highly correlated with `neighbourhood`	High correlation
`neighbourhood` is highly correlated with `dublinNorthSouth`	High correlation
`title` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`floorArea` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`deltaMedianPrice` has 53 (4.1%) zeros	Zeros

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct count	1299
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1512.7397998460353
Minimum	6
Maximum	3030
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 KiB

Quantile statistics

Minimum	6
5-th percentile	222.5
Q1	841.5
median	1507
Q3	2175
95-th percentile	2821.6
Maximum	3030
Range	3024
Interquartile range (IQR)	1333.5

Descriptive statistics

Standard deviation	816.3766833
Coefficient of variation (CV)	0.5396676173
Kurtosis	-1.06988594
Mean	1512.7398
Median Absolute Deviation (MAD)	667
Skewness	0.0181515652
Sum	1965049
Variance	666470.8891

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2048	1	0.1%
1279	1	0.1%
2834	1	0.1%
1311	1	0.1%
1310	1	0.1%
1307	1	0.1%
1306	1	0.1%
1305	1	0.1%
1303	1	0.1%
1302	1	0.1%
Other values (1289)	1289	99.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	1	0.1%
11	1	0.1%
12	1	0.1%
13	1	0.1%
15	1	0.1%

Value	Count	Frequency (%)
3030	1	0.1%
3028	1	0.1%
3026	1	0.1%
3009	1	0.1%
3005	1	0.1%

title
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	1291
Unique (%)	99.4%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

Apartment 101, Milltown Hall, Milltown Avenue, Mount Saint Annes, Milltown, Dublin 6	2
24 The Wood, Millbrook Lawns, Tallaght, Dublin 24	2
88 Scholarstown Park, Rathfarnham, Dublin 16	2
26 Grace Park Court, Beaumont Road, Beaumont, Dublin 9	2
20 Muckross Green, Perrystown, Dublin 12	2
Other values (1286)	1289

Value	Count	Frequency (%)
Apartment 101, Milltown Hall, Milltown Avenue, Mount Saint Annes, Milltown, Dublin 6	2	0.2%
24 The Wood, Millbrook Lawns, Tallaght, Dublin 24	2	0.2%
88 Scholarstown Park, Rathfarnham, Dublin 16	2	0.2%
26 Grace Park Court, Beaumont Road, Beaumont, Dublin 9	2	0.2%
20 Muckross Green, Perrystown, Dublin 12	2	0.2%
20 Moyclare Road, Baldoyle, Dublin 13	2	0.2%
Apartment 427, The Old Chocolate Factory, Kilmainham Square, Kilmainham, Dublin 8	2	0.2%
171 Drimnagh Road, Drimnagh, Dublin 12	2	0.2%
36 Cloyne Road, Kimmage, Dublin 12	1	0.1%
Apartment 39, Rope Walk Place, Ringsend, Dublin 4	1	0.1%
Other values (1281)	1281	98.6%

Length

Max length	84
Mean length	45.08929946
Min length	22

Value	Count	Frequency (%)
Lowercase_Letter	27	38.0%
Uppercase_Letter	25	35.2%
Decimal_Number	10	14.1%
Other_Punctuation	4	5.6%
Connector_Punctuation	1	1.4%
Close_Punctuation	1	1.4%
Dash_Punctuation	1	1.4%
Open_Punctuation	1	1.4%
Space_Separator	1	1.4%

Value	Count	Frequency (%)
Latin	52	73.2%
Common	19	26.8%

Value	Count	Frequency (%)
ASCII	70	100.0%

neighbourhood
Categorical

HIGH CORRELATION

Distinct count	22
Unique (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

Dublin 15	124
Dublin 11	107
Dublin 8	91
Dublin 9	85
Dublin 3	84
Other values (17)	808

Value	Count	Frequency (%)
Dublin 15	124	9.5%
Dublin 11	107	8.2%
Dublin 8	91	7.0%
Dublin 9	85	6.5%
Dublin 3	84	6.5%
Dublin 4	75	5.8%
Dublin 14	74	5.7%
Dublin 24	71	5.5%
Dublin 12	71	5.5%
Dublin 7	69	5.3%
Other values (12)	448	34.5%

Length

Max length	9
Mean length	8.541185527
Min length	8

Value	Count	Frequency (%)
Decimal_Number	10	55.6%
Lowercase_Letter	5	27.8%
Uppercase_Letter	2	11.1%
Space_Separator	1	5.6%

Value	Count	Frequency (%)
Common	11	61.1%
Latin	7	38.9%

Value	Count	Frequency (%)
ASCII	18	100.0%

propertyType
Categorical

Distinct count	10
Unique (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

Apartment	403
Terrace	342
Semi-D	292
End of Terrace	117
Detached	67
Other values (5)	78

Value	Count	Frequency (%)
Apartment	403	31.0%
Terrace	342	26.3%
Semi-D	292	22.5%
End of Terrace	117	9.0%
Detached	67	5.2%
Duplex	31	2.4%
Bungalow	18	1.4%
Site	14	1.1%
Townhouse	14	1.1%
Studio	1	0.1%

Length

Max length	14
Mean length	8.056197075
Min length	4

Value	Count	Frequency (%)
Lowercase_Letter	19	70.4%
Uppercase_Letter	6	22.2%
Dash_Punctuation	1	3.7%
Space_Separator	1	3.7%

Value	Count	Frequency (%)
Latin	25	92.6%
Common	2	7.4%

Value	Count	Frequency (%)
ASCII	27	100.0%

numBedrooms
Real number (ℝ)

Distinct count	9
Unique (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.6243264049268666
Minimum	-1.0
Maximum	11.0
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 KiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	2
median	3
Q3	3
95-th percentile	4
Maximum	11
Range	12
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.028361782
Coefficient of variation (CV)	0.391857423
Kurtosis	4.868244502
Mean	2.624326405
Median Absolute Deviation (MAD)	1
Skewness	0.4171197651
Sum	3409
Variance	1.057527955

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
3	525	40.4%
2	472	36.3%
4	136	10.5%
1	102	7.9%
5	42	3.2%
-1	15	1.2%
6	4	0.3%
7	2	0.2%
11	1	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	15	1.2%
1	102	7.9%
2	472	36.3%
3	525	40.4%
4	136	10.5%

Value	Count	Frequency (%)
11	1	0.1%
7	2	0.2%
6	4	0.3%
5	42	3.2%
4	136	10.5%

numBathrooms
Real number (ℝ)

Distinct count	7
Unique (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.6274056966897614
Minimum	-1.0
Maximum	6.0
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 KiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	6
Range	7
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.8362291347
Coefficient of variation (CV)	0.5138418382
Kurtosis	2.413610985
Mean	1.627405697
Median Absolute Deviation (MAD)	1
Skewness	0.677925622
Sum	2114
Variance	0.6992791658

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	633	48.7%
2	479	36.9%
3	144	11.1%
-1	18	1.4%
4	18	1.4%
5	5	0.4%
6	2	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	18	1.4%
1	633	48.7%
2	479	36.9%
3	144	11.1%
4	18	1.4%

Value	Count	Frequency (%)
6	2	0.2%
5	5	0.4%
4	18	1.4%
3	144	11.1%
2	479	36.9%

floorArea
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

price
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	187
Unique (%)	14.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	393785.2193995381
Minimum	75000.0
Maximum	2500000.0
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 KiB

Quantile statistics

Minimum	75000
5-th percentile	195000
Q1	260000
median	345000
Q3	450000
95-th percentile	795000
Maximum	2500000
Range	2425000
Interquartile range (IQR)	190000

Descriptive statistics

Standard deviation	220680.4631
Coefficient of variation (CV)	0.5604081926
Kurtosis	21.37023469
Mean	393785.2194
Median Absolute Deviation (MAD)	95000
Skewness	3.441321648
Sum	511527000
Variance	4.869986678e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
275000	42	3.2%
350000	41	3.2%
250000	37	2.8%
395000	35	2.7%
375000	33	2.5%
425000	33	2.5%
325000	31	2.4%
295000	31	2.4%
450000	30	2.3%
260000	29	2.2%
Other values (177)	957	73.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
75000	1	0.1%
95000	1	0.1%
135000	2	0.2%
139000	1	0.1%
140000	3	0.2%

Value	Count	Frequency (%)
2500000	2	0.2%
2300000	1	0.1%
1800000	1	0.1%
1700000	1	0.1%
1600000	2	0.2%

rating
Categorical

Distinct count	16
Unique (%)	1.2%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

D2	173
D1	155
C2	129
C3	124
C1	112
Other values (11)	606

Value	Count	Frequency (%)
D2	173	13.3%
D1	155	11.9%
C2	129	9.9%
C3	124	9.5%
C1	112	8.6%
E1	105	8.1%
B3	92	7.1%
E2	88	6.8%
F	81	6.2%
G	70	5.4%
Other values (6)	170	13.1%

Length

Max length	6
Mean length	2.076212471
Min length	1

Value	Count	Frequency (%)
Uppercase_Letter	10	66.7%
Decimal_Number	4	26.7%
Connector_Punctuation	1	6.7%

Value	Count	Frequency (%)
Latin	10	66.7%
Common	5	33.3%

Value	Count	Frequency (%)
ASCII	15	100.0%

sellerId
Real number (ℝ_≥0)

Distinct count	195
Unique (%)	15.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5756.895304080062
Minimum	7
Maximum	11902
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 KiB

Quantile statistics

Minimum	7
5-th percentile	12
Q1	1367
median	6962
Q3	9737
95-th percentile	11062
Maximum	11902
Range	11895
Interquartile range (IQR)	8370

Descriptive statistics

Standard deviation	4203.177831
Coefficient of variation (CV)	0.7301119109
Kurtosis	-1.645741789
Mean	5756.895304
Median Absolute Deviation (MAD)	3987
Skewness	-0.09081358387
Sum	7478207
Variance	17666703.88

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
11062	45	3.5%
10947	44	3.4%
11	39	3.0%
7569	39	3.0%
8505	35	2.7%
1413	33	2.5%
12	31	2.4%
3658	29	2.2%
6498	27	2.1%
9172	24	1.8%
Other values (185)	953	73.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7	6	0.5%
11	39	3.0%
12	31	2.4%
49	13	1.0%
56	8	0.6%

Value	Count	Frequency (%)
11902	5	0.4%
11899	1	0.1%
11766	5	0.4%
11754	1	0.1%
11720	2	0.2%

longitude
Real number (ℝ)

Distinct count	1265
Unique (%)	97.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-6.281105550088232
Minimum	-6.443882
Maximum	-6.055211
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 KiB

Quantile statistics

Minimum	-6.443882
5-th percentile	-6.403495
Q1	-6.32122465
median	-6.276468
Q3	-6.235783
95-th percentile	-6.1698893
Maximum	-6.055211
Range	0.388671
Interquartile range (IQR)	0.08544165

Descriptive statistics

Standard deviation	0.07043407581
Coefficient of variation (CV)	-0.01121364308
Kurtosis	-0.04100664671
Mean	-6.28110555
Median Absolute Deviation (MAD)	0.041914
Skewness	-0.08297661482
Sum	-8159.15611
Variance	0.004960959035

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
-6.227282	3	0.2%
-6.309374	3	0.2%
-6.264954	2	0.2%
-6.23838	2	0.2%
-6.2834	2	0.2%
-6.264883	2	0.2%
-6.31234	2	0.2%
-6.248074	2	0.2%
-6.172943	2	0.2%
-6.27907	2	0.2%
Other values (1255)	1277	98.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-6.443882	1	0.1%
-6.443585	1	0.1%
-6.442693	1	0.1%
-6.441123	1	0.1%
-6.440754	1	0.1%

Value	Count	Frequency (%)
-6.055211	1	0.1%
-6.059735	1	0.1%
-6.065742	1	0.1%
-6.066756	1	0.1%
-6.06714	1	0.1%

latitude
Real number (ℝ_≥0)

Distinct count	1264
Unique (%)	97.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	53.3444065219388
Minimum	53.21904
Maximum	53.433172
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 KiB

Quantile statistics

Minimum	53.21904
5-th percentile	53.2713847
Q1	53.318724
median	53.34549
Q3	53.3811215
95-th percentile	53.40107415
Maximum	53.433172
Range	0.214132
Interquartile range (IQR)	0.0623975

Descriptive statistics

Standard deviation	0.0415737757
Coefficient of variation (CV)	0.0007793464846
Kurtosis	-0.6420920591
Mean	53.34440652
Median Absolute Deviation (MAD)	0.031599
Skewness	-0.4105714573
Sum	69294.38407
Variance	0.001728378826

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
53.342931	3	0.2%
53.341431	3	0.2%
53.34549	2	0.2%
53.347308	2	0.2%
53.31296	2	0.2%
53.314145	2	0.2%
53.379986	2	0.2%
53.26935	2	0.2%
53.399981	2	0.2%
53.313725	2	0.2%
Other values (1254)	1277	98.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
53.21904	1	0.1%
53.226358	1	0.1%
53.228438	1	0.1%
53.229695	1	0.1%
53.233209	1	0.1%

Value	Count	Frequency (%)
53.433172	1	0.1%
53.432174	1	0.1%
53.431643	1	0.1%
53.422947	1	0.1%
53.422198	1	0.1%

pricePerBedroom
Real number (ℝ)

Distinct count	297
Unique (%)	22.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	146597.81516917775
Minimum	-1500000.0
Maximum	625000.0
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 KiB

Quantile statistics

Minimum	-1500000
5-th percentile	76666.66667
Q1	107500
median	137500
Q3	184250
95-th percentile	274550
Maximum	625000
Range	2125000
Interquartile range (IQR)	76750

Descriptive statistics

Standard deviation	99775.92229
Coefficient of variation (CV)	0.6806098861
Kurtosis	80.02294961
Mean	146597.8152
Median Absolute Deviation (MAD)	37500
Skewness	-5.54567141
Sum	190430561.9
Variance	9955234668

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
125000	34	2.6%
150000	34	2.6%
175000	29	2.2%
137500	23	1.8%
95000	21	1.6%
112500	20	1.5%
187500	20	1.5%
165000	19	1.5%
131666.6667	18	1.4%
115000	18	1.4%
Other values (287)	1063	81.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1500000	1	0.1%
-850000	2	0.2%
-745000	1	0.1%
-498000	1	0.1%
-350000	1	0.1%

Value	Count	Frequency (%)
625000	2	0.2%
600000	1	0.1%
497500	1	0.1%
460000	1	0.1%
450000	2	0.2%

deltaAvgPrice
Real number (ℝ)

HIGH CORRELATION

Distinct count	799
Unique (%)	61.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	18200.619426402525
Minimum	-1781852.1739130435
Maximum	488147.82608695654
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 KiB

Quantile statistics

Minimum	-1781852.174
5-th percentile	-276450.8424
Q1	-39536.91275
median	42167.40088
Q3	106614.7018
95-th percentile	270454.5911
Maximum	488147.8261
Range	2270000
Interquartile range (IQR)	146151.6145

Descriptive statistics

Standard deviation	192959.968
Coefficient of variation (CV)	10.60183522
Kurtosis	19.73630525
Mean	18200.61943
Median Absolute Deviation (MAD)	72731.82393
Skewness	-2.904687946
Sum	23642604.63
Variance	3.723354925e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
-20409.83607	8	0.6%
65231.25	7	0.5%
55231.25	7	0.5%
16102.94118	7	0.5%
93459.45946	7	0.5%
62167.40088	7	0.5%
14529.80132	6	0.5%
343147.8261	6	0.5%
102167.4009	6	0.5%
68459.45946	6	0.5%
Other values (789)	1232	94.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1781852.174	2	0.2%
-1581852.174	1	0.1%
-1334772.358	1	0.1%
-1054396.947	1	0.1%
-1007273.973	1	0.1%

Value	Count	Frequency (%)
488147.8261	1	0.1%
468147.8261	1	0.1%
446603.0534	1	0.1%
435603.0534	1	0.1%
428147.8261	1	0.1%

deltaMedianPrice
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count	275
Unique (%)	21.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-30248.267898383372
Minimum	-1990000.0
Maximum	326000.0
Zeros	53
Zeros (%)	4.1%
Memory size	10.3 KiB

Quantile statistics

Minimum	-1990000
5-th percentile	-345400
Q1	-73500
median	5000
Q3	65000
95-th percentile	170000
Maximum	326000
Range	2316000
Interquartile range (IQR)	138500

Descriptive statistics

Standard deviation	193812.0509
Coefficient of variation (CV)	-6.407376831
Kurtosis	26.72262439
Mean	-30248.2679
Median Absolute Deviation (MAD)	65000
Skewness	-3.785778077
Sum	-39292500
Variance	3.756311108e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	53	4.1%
50000	32	2.5%
25000	30	2.3%
75000	29	2.2%
100000	29	2.2%
20000	28	2.2%
15000	23	1.8%
-10000	22	1.7%
55000	21	1.6%
65000	20	1.5%
Other values (265)	1012	77.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1990000	2	0.2%
-1790000	1	0.1%
-1405000	1	0.1%
-1175000	1	0.1%
-1090000	2	0.2%

Value	Count	Frequency (%)
326000	1	0.1%
315000	1	0.1%
305000	1	0.1%
290000	2	0.2%
285000	2	0.2%

dublinNorthSouth
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	10.3 KiB

S	673
N	626

Value	Count	Frequency (%)
S	673	51.8%
N	626	48.2%

Length

Max length	1
Mean length	1
Min length	1

Value	Count	Frequency (%)
Uppercase_Letter	2	100.0%

Value	Count	Frequency (%)
Latin	2	100.0%

Value	Count	Frequency (%)
ASCII	2	100.0%

distToCity
Real number (ℝ_≥0)

Distinct count	1268
Unique (%)	97.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.870918474761994
Minimum	0.09991156306907832
Maximum	17.012878032749462
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 KiB

Quantile statistics

Minimum	0.09991156307
5-th percentile	1.341016621
Q1	3.060153685
median	5.08424187
Q3	8.606567924
95-th percentile	12.02436493
Maximum	17.01287803
Range	16.91296647
Interquartile range (IQR)	5.546414238

Descriptive statistics

Standard deviation	3.458445228
Coefficient of variation (CV)	0.589080779
Kurtosis	-0.5518558965
Mean	5.870918475
Median Absolute Deviation (MAD)	2.565375638
Skewness	0.5426284354
Sum	7626.323099
Variance	11.9608434

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2.415355904	3	0.2%
3.590435795	3	0.2%
2.213178012	2	0.2%
8.438129316	2	0.2%
1.841780665	2	0.2%
4.401617511	2	0.2%
1.986795776	2	0.2%
5.764686977	2	0.2%
0.937056004	2	0.2%
0.4831172059	2	0.2%
Other values (1258)	1277	98.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.09991156307	1	0.1%
0.1835478493	1	0.1%
0.2065863985	2	0.2%
0.3172734398	1	0.1%
0.3828696698	1	0.1%

Value	Count	Frequency (%)
17.01287803	1	0.1%
16.56325022	1	0.1%
16.47248576	1	0.1%
16.37153247	1	0.1%
16.35529162	1	0.1%

daysSincePublished
Real number (ℝ_≥0)

Distinct count	155
Unique (%)	11.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	79.3448806774442
Minimum	2
Maximum	333
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 KiB

Quantile statistics

Minimum	2
5-th percentile	12
Q1	47
median	81
Q3	107
95-th percentile	144
Maximum	333
Range	331
Interquartile range (IQR)	60

Descriptive statistics

Standard deviation	42.41735818
Coefficient of variation (CV)	0.5345947694
Kurtosis	2.044387728
Mean	79.34488068
Median Absolute Deviation (MAD)	28
Skewness	0.585147297
Sum	103069
Variance	1799.232275

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
97	36	2.8%
68	35	2.7%
48	35	2.7%
80	27	2.1%
109	25	1.9%
100	25	1.9%
81	25	1.9%
88	24	1.8%
32	24	1.8%
108	23	1.8%
Other values (145)	1020	78.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	6	0.5%
3	9	0.7%
4	3	0.2%
5	8	0.6%
6	9	0.7%

Value	Count	Frequency (%)
333	1	0.1%
330	1	0.1%
297	1	0.1%
223	1	0.1%
222	1	0.1%

numFood
Real number (ℝ_≥0)

Distinct count	44
Unique (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	46.47036181678214
Minimum	11
Maximum	59
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 KiB

Quantile statistics

Minimum	11
5-th percentile	30
Q1	42
median	49
Q3	52
95-th percentile	56
Maximum	59
Range	48
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	8.097803966
Coefficient of variation (CV)	0.1742573901
Kurtosis	1.566891463
Mean	46.47036182
Median Absolute Deviation (MAD)	4
Skewness	-1.26027652
Sum	60365
Variance	65.57442907

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
51	113	8.7%
52	103	7.9%
49	88	6.8%
53	87	6.7%
48	85	6.5%
50	78	6.0%
54	58	4.5%
55	58	4.5%
47	54	4.2%
46	52	4.0%
Other values (34)	523	40.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
11	2	0.2%
13	1	0.1%
15	2	0.2%
16	2	0.2%
19	2	0.2%

Value	Count	Frequency (%)
59	2	0.2%
58	9	0.7%
57	26	2.0%
56	48	3.7%
55	58	4.5%

numRecreation
Real number (ℝ_≥0)

Distinct count	23
Unique (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	12.291762894534257
Minimum	1
Maximum	23
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	10
median	13
Q3	15
95-th percentile	18
Maximum	23
Range	22
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.847879958
Coefficient of variation (CV)	0.3130454103
Kurtosis	-0.1041382073
Mean	12.29176289
Median Absolute Deviation (MAD)	2
Skewness	-0.4682915977
Sum	15967
Variance	14.80618017

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
12	144	11.1%
15	144	11.1%
13	143	11.0%
14	131	10.1%
11	116	8.9%
16	99	7.6%
10	80	6.2%
17	75	5.8%
9	70	5.4%
18	51	3.9%
Other values (13)	246	18.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	4	0.3%
2	4	0.3%
3	16	1.2%
4	24	1.8%
5	44	3.4%

Value	Count	Frequency (%)
23	1	0.1%
22	3	0.2%
21	3	0.2%
20	6	0.5%
19	22	1.7%

numShop
Real number (ℝ_≥0)

Distinct count	36
Unique (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10.85604311008468
Minimum	1
Maximum	36
Zeros	0
Zeros (%)	0.0%
Memory size	10.3 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	4
median	7
Q3	17
95-th percentile	30
Maximum	36
Range	35
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	8.642803862
Coefficient of variation (CV)	0.796128366
Kurtosis	0.003035512463
Mean	10.85604311
Median Absolute Deviation (MAD)	3
Skewness	1.070896143
Sum	14102
Variance	74.6980586

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4	348	26.8%
5	118	9.1%
7	79	6.1%
6	76	5.9%
2	45	3.5%
9	39	3.0%
11	37	2.8%
8	37	2.8%
20	35	2.7%
3	32	2.5%
Other values (26)	453	34.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	11	0.8%
2	45	3.5%
3	32	2.5%
4	348	26.8%
5	118	9.1%

Value	Count	Frequency (%)
36	1	0.1%
35	2	0.2%
34	7	0.5%
33	26	2.0%
32	10	0.8%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

First rows

	df_index	title	neighbourhood	propertyType	numBedrooms	numBathrooms	floorArea	price	rating	sellerId	longitude	latitude	pricePerBedroom	deltaAvgPrice	deltaMedianPrice	dublinNorthSouth	distToCity	daysSincePublished	numFood	numRecreation	numShop
0	6	Apartment 172, Block C, Dublin 7	Dublin 7	Apartment	1.0	1.0	51	250000.0	C1	1331	-6.277584	53.348715	250000.000000	137061.403509	100000.0	N	1.387431	3	53	13	4
1	11	Apartment 48, Beacon, Ashtown, Dublin 15	Dublin 15	Apartment	1.0	1.0	45	210000.0	C1	4274	-6.310559	53.376695	210000.000000	127167.400881	75000.0	N	4.361361	12	48	18	3
2	12	Apartment 15, Blackhall Court, Stoneybatter, Dublin 7	Dublin 7	Apartment	2.0	1.0	46	250000.0	E2	948	-6.282134	53.349442	125000.000000	137061.403509	100000.0	N	1.651646	9	51	13	4
3	13	Apartment 127, Block B, Lymewood Mews, Northwood, Santry, Dublin 9	Dublin 9	Apartment	2.0	2.0	70	275000.0	C2	3658	-6.256419	53.402848	137500.000000	114529.801325	100000.0	N	5.529245	5	49	11	9
4	15	46 Oxmantown Road, Stoneybatter, Dublin 7	Dublin 7	Terrace	2.0	-1.0	56	280000.0	F	1087	-6.291654	53.353738	140000.000000	107061.403509	70000.0	N	2.233330	9	52	12	4
5	18	71 Parklands Court, Ballycullen, Dublin 16	Dublin 16	Apartment	2.0	1.0	70	255000.0	ZZZ	8210	-6.341428	53.274936	127500.000000	237726.027397	220000.0	S	10.301642	9	28	9	23
6	19	24 The Wood, Millbrook Lawns, Tallaght, Dublin 24	Dublin 24	Terrace	3.0	1.0	90	285000.0	ZZZ	8210	-6.355033	53.281759	95000.000000	4899.224806	0.0	S	10.214784	9	37	7	31
7	42	43 Woodlawn Drive, Santry, Dublin 9	Dublin 9	Semi-D	3.0	3.0	97	350000.0	D2	9405	-6.233257	53.401033	116666.666667	39529.801325	25000.0	N	5.573387	3	52	12	13
8	48	Apartment 201, The Cubes 1, Beacon South Quarter, Sandyford, Dublin 18	Dublin 18	Apartment	2.0	2.0	80	350000.0	C1	8532	-6.216098	53.276637	175000.000000	165438.095238	80000.0	S	8.940731	9	38	14	23
9	53	9 Mount Argus Green, Harold's Cross, Dublin 6W	Dublin 6W	Terrace	3.0	2.0	90	460000.0	C2	967	-6.288795	53.322564	153333.333333	40264.705882	12500.0	S	3.961029	17	48	15	6

Last rows

	df_index	title	neighbourhood	propertyType	numBedrooms	numBathrooms	floorArea	price	rating	sellerId	longitude	latitude	pricePerBedroom	deltaAvgPrice	deltaMedianPrice	dublinNorthSouth	distToCity	daysSincePublished	numFood	numRecreation	numShop
1289	2984	3 Kilmartin Gardens, Tallaght, Dublin 24	Dublin 24	Terrace	3.0	1.0	92	185000.0	ZZZ	8210	-6.399694	53.291152	61666.666667	104899.224806	100000.0	S	11.655326	98	36	6	29
1290	2990	10 Shamrock Cottages, North Strand, Dublin 3	Dublin 3	Townhouse	2.0	1.0	49	200000.0	G	2050	-6.244140	53.355253	100000.000000	265227.642276	195000.0	N	0.949914	18	55	13	4
1291	2994	5 Dun Emer Drive, Dundrum, Dublin 14	Dublin 14	Semi-D	4.0	1.0	138	645000.0	D2	49	-6.236976	53.282698	161250.000000	-71406.250000	-95000.0	S	7.946910	107	47	10	12
1292	2998	133 Kiltipper Gate, Tallaght, Dublin 24	Dublin 24	Apartment	2.0	2.0	70	215000.0	ZZZ	8210	-6.370672	53.269495	107500.000000	74899.224806	70000.0	S	11.927989	9	21	5	22
1293	3000	19 Beneavin Park, Glasnevin, Dublin 11	Dublin 11	Semi-D	3.0	1.0	97	370000.0	D2	841	-6.283289	53.389930	123333.333333	-79768.750000	-115000.0	N	4.422859	89	54	18	2
1294	3005	2 Florence Street, Portobello, Dublin 8	Dublin 8	Terrace	3.0	2.0	124	595000.0	E2	8456	-6.269723	53.331242	198333.333333	-251540.540541	-300000.0	S	2.550457	83	53	14	6
1295	3009	9 Saint Johns Court, Kilmore Road, Artane, Dublin 5	Dublin 5	Terrace	2.0	1.0	71	285000.0	C3	1063	-6.218931	53.390851	142500.000000	101168.000000	90000.0	N	4.930323	18	56	13	7
1296	3026	122 Connaught Street, Phibsborough, Dublin 7	Dublin 7	Terrace	3.0	1.0	100	550000.0	E2	841	-6.279345	53.363448	183333.333333	-162938.596491	-200000.0	N	1.823827	114	56	11	4
1297	3028	10 Ard Na Greine, Eaton Brae, off Orwell Road, Rathgar, Dublin 6	Dublin 6	Terrace	2.0	2.0	144	900000.0	A3	9460	-6.261595	53.303673	450000.000000	-254396.946565	-375000.0	S	5.497794	41	46	17	8
1298	3030	3 Marian Drive, Rathfarnham, Dublin 14	Dublin 14	Detached	5.0	3.0	214	850000.0	C1	11062	-6.296157	53.295243	170000.000000	-276406.250000	-300000.0	S	6.910201	20	49	11	9

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows